KommerceServer Import API Specifications
Following is a list of import APIs that are available to you in KommerceServer. APIs must be sent based on an order of precedence because the KommerceServer database maintains referential integrity.
The Import API names shown below include standard integration ID which can be different.
|
Precedence |
Import API Name |
Description of Use |
Available in webPortal? |
Available in webStore? |
|---|---|---|---|---|
| 1 |
Internal category for Items |
Yes |
Yes |
|
| 1 |
KS_CLASSIFICATIONS |
Business and/or contact classification codes |
No |
No |
| 1 |
Collection of companies selling competitive products (products will be cross-referenced) |
No |
{Yes} |
|
| 1 |
Currency Codes |
{Yes} |
{Yes} |
|
| 1 |
Hierarchical sales department structure for the host company (not for use by external customers) |
No |
No |
|
| 1 |
KS_FAILURE_CODES |
List of failure codes related to Return Material Authorizations or service calls |
No |
No |
| 1 |
Shipping Methods and estimated freight rates by weight or amount |
No |
Yes |
|
| 1 |
KS_REGIONS |
Hierarchical sales regions with associated sales reps |
No |
No |
| 1 |
KS_RMA_TYPES |
List of Return Material Authorization types |
No |
No |
| 1 |
Sales tax codes and tax rates |
No |
Yes |
|
| 1 |
KS_SERVICE_TYPES |
List of various labor services performed on service calls |
No |
No |
| 1 |
Special Charge Codes which are associated to store items |
{Yes} |
{Yes} |
|
| 1 |
KS_WARRANTY_CODES |
Warranty codes related to serial controlled items |
No |
No |
| 2 |
Customer information with primary address |
Yes |
Yes |
|
| 2 |
KS_ENDUSERS |
End Users are companies that are indirect customers via dealers/distributors (Parallel dataset to KS_CUSTOMERS) |
No |
No |
| 2 |
Current exchange rates from the foreign currency code to the functional currency of the website |
{Yes} |
{Yes} |
|
| 2 |
Basic item master information |
Yes |
Yes |
|
| 2 |
KS_REPQUOTA |
Sales quota by sales rep for reporting purposes |
No |
No |
| 3 |
Extended site specific item information (e.g. Price Sheet) |
No |
Yes |
|
| 3 |
Cross reference of competitor items to sellable items |
No |
{Yes} |
|
| 3 |
Customer cross reference part numbers to host company part numbers. |
No |
{Yes} |
|
| 3 |
Geographical restriction data used by the storefront to prevent shipments to locations for certain products |
No |
{Yes} |
|
| 3 |
Inventory for items by inventory location |
No |
{Yes} |
|
| 3 |
KS_MODELS |
Product Models with associated option and rule sets |
No |
No |
| 3 |
KS_OPTIONS |
Product configurator Option Sets (not specific to a particular model) |
No |
No |
| 3 |
Sales Order transactions including line item and delivery information |
Yes |
No |
|
| 3 |
Price discounts or markups by volume and combination of customer, customer class, product, or product class |
No |
Yes |
|
| 3 |
KS_QUOTES |
Sales quotations for prospects and customers |
No |
No |
| 3 |
Return Material Authorization transactions including line item and delivery information (parallel dataset to KS_ORDERS) |
Yes |
No |
|
| 3 |
KS_RULES |
Product configurator Rule Sets (not specific to a particular model) |
No |
No |
| 3 |
KS_SERVICE_CHARGES |
Service charges related to service calls |
No |
No |
| 3 |
Additional office location addresses for customers (i.e. warehouse, sales office, etc.) |
No |
Yes |
|
| 3 |
Base prices for items by price code (i.e. Price Lists) |
No |
{Yes} |
|
| 3 |
Contacts for customers or end users |
Yes |
Yes |
|
| 4 |
Return Material Authorization receipt transactions (parallel dataset to KS_SHIPMENTS) |
Yes |
No |
|
| 4 |
Shipment transactions for sales orders; Also supports reverse shipments (i.e. receipts which are treated like RMAs) |
Yes |
No |
|
| 5 |
Invoice transactions for sales orders, RMAs, and manual invoices |
Yes |
No |
|
| 5 |
Serial Controlled Item transaction cross reference and warranty information |
{Yes} |
No |
|
| 6 |
KS_COMMISSIONS |
Commission detail data from invoices and adjustments |
No |
No |
Related Topics